SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweCapacitandos
AS
SELECT     idCapacitacion AS ID, Agente, Capacitacion, Fecha, TipoEntidad, Aprobado
FROM         dbo.tb_CapacitacionesDelAgente
GO
GRANT SELECT ON  [dbo].[vweCapacitandos] TO [Juntas]
GRANT INSERT ON  [dbo].[vweCapacitandos] TO [Juntas]
GRANT DELETE ON  [dbo].[vweCapacitandos] TO [Juntas]
GRANT UPDATE ON  [dbo].[vweCapacitandos] TO [Juntas]
GRANT SELECT ON  [dbo].[vweCapacitandos] TO [SoloVer]
GO
